Tabela DgActiveSubstance

Definicja tabeli DgActiveSubstance

Name

DgActiveSubstance

Code

DgActiveSubstance

Comment

dane o substancjach aktywnych


Lista kolumn tabeli DgActiveSubstance

Name

Code

ActiveSubstanceID

ActiveSubstanceID

DrugDBTypeID

DrugDBTypeID

ExternalID

ExternalID

Active

Active

Name

Name


Kolumna ActiveSubstanceID tabeli DgActiveSubstance

Definicja kolumny ActiveSubstanceID tabeli DgActiveSubstance

Name

ActiveSubstanceID

Code

ActiveSubstanceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID substancji aktywnej


Kolumna DrugDBTypeID tabeli DgActiveSubstance

Definicja kolumny DrugDBTypeID tabeli DgActiveSubstance

Name

DrugDBTypeID

Code

DrugDBTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExternalID tabeli DgActiveSubstance

Definicja kolumny ExternalID tabeli DgActiveSubstance

Name

ExternalID

Code

ExternalID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

klucz glówny z zewnetrznego systemu


Kolumna Active tabeli DgActiveSubstance

Definicja kolumny Active tabeli DgActiveSubstance

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Kolumna Name tabeli DgActiveSubstance

Definicja kolumny Name tabeli DgActiveSubstance

Name

Name

Code

Name

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Lista kluczy tabeli DgActiveSubstance

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DgActiveSubstance

Definicja klucza Identifier_1 tabeli DgActiveSubstance

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment